Node / ReticulumProjects / MeshChatX.git / files / tests / backend / test_announce_spam_sqlite.py

Displaying Raw • Download

T8b949e# SPDX-License-Identifier: 0BSD

T8b949e"""SQLite integration: announce spam and bounded storage (anti-exhaustion).

Multi-minute soak scenarios live in ``test_long_running_stress.py`` (opt-in via

``MESHCHAT_LONG_TEST_SECONDS``).

"""

Tff7b72from T7ee787__future__ Tff7b72import Te6edf3annotations

Tff7b72import T7ee787os

Tff7b72import T7ee787tempfile

Tff7b72from T7ee787unittestT7ee787.T7ee787mock Tff7b72import Te6edf3MagicMock

Tff7b72import T7ee787pytest

Tff7b72from T7ee787meshchatxT7ee787.T7ee787srcT7ee787.T7ee787backendT7ee787.T7ee787announce_manager Tff7b72import Te6edf3AnnounceManager

Tff7b72from T7ee787meshchatxT7ee787.T7ee787srcT7ee787.T7ee787backendT7ee787.T7ee787database Tff7b72import Te6edf3Database

Tff7b72from T7ee787meshchatxT7ee787.T7ee787srcT7ee787.T7ee787backendT7ee787.T7ee787databaseT7ee787.T7ee787provider Tff7b72import Te6edf3DatabaseProvider

Tff7b72class T56d364_FakeIdentityTb4b4b4:

Tff7b72__slots__ Tff7b72= Tb4b4b4(Ta5d6ff"Ta5d6ff_hTa5d6ff"Tb4b4b4,Tb4b4b4)

Tff7b72def Tff7b72__init__Tb4b4b4(Tff7b72selfTb4b4b4, Te6edf3identity_hex32Tb4b4b4: Tffa657strTb4b4b4)Tb4b4b4:

Tff7b72selfTff7b72.Td2a8ff_h Tff7b72= Tffa657bytesTff7b72.Td2a8fffromhexTb4b4b4(Te6edf3identity_hex32Tb4b4b4)

Tf0883e@property

Tff7b72def Td2a8ffhashTb4b4b4(Tff7b72selfTb4b4b4)Tb4b4b4:

Tff7b72return Tff7b72selfTff7b72.Td2a8ff_h

Tff7b72def Td2a8ffget_public_keyTb4b4b4(Tff7b72selfTb4b4b4)Tb4b4b4:

Tff7b72return Ta5d6ffbTa5d6ff"Tffea00\xaaTffea00\xbbTa5d6ff"

Tff7b72def Td2a8ff_cleanupTb4b4b4(Te6edf3dbTb4b4b4, Te6edf3pathTb4b4b4)Tb4b4b4:

Tff7b72if Te6edf3db Tff7b72is Tff7b72not Tff7b72NoneTb4b4b4:

Tff7b72tryTb4b4b4:

Te6edf3dbTff7b72.Td2a8ffcloseTb4b4b4(Tb4b4b4)

Tff7b72except Tf85149ExceptionTb4b4b4:

Tff7b72pass

Te6edf3DatabaseProviderTff7b72.Td2a8ff_instance Tff7b72= Tff7b72None

Tff7b72if Te6edf3pathTb4b4b4:

Tff7b72tryTb4b4b4:

Te6edf3osTff7b72.Td2a8ffunlinkTb4b4b4(Te6edf3pathTb4b4b4)

Tff7b72except Tf85149OSErrorTb4b4b4:

Tff7b72pass

Tff7b72for Te6edf3suffix Tff7b72in Tb4b4b4(Ta5d6ff"Ta5d6ff-walTa5d6ff"Tb4b4b4, Ta5d6ff"Ta5d6ff-shmTa5d6ff"Tb4b4b4)Tb4b4b4:

Tff7b72tryTb4b4b4:

Te6edf3osTff7b72.Td2a8ffunlinkTb4b4b4(Te6edf3path Tff7b72+ Te6edf3suffixTb4b4b4)

Tff7b72except Tf85149OSErrorTb4b4b4:

Tff7b72pass

Tff7b72def Td2a8ff_new_dbTb4b4b4(Tb4b4b4)Tb4b4b4:

Tff7b72with Te6edf3tempfileTff7b72.Td2a8ffNamedTemporaryFileTb4b4b4(Te6edf3suffixTff7b72=Ta5d6ff"Ta5d6ff.dbTa5d6ff"Tb4b4b4, Te6edf3deleteTff7b72=Tff7b72FalseTb4b4b4) Tff7b72as Te6edf3fTb4b4b4:

Te6edf3path Tff7b72= Te6edf3fTff7b72.Td2a8ffname

Te6edf3db Tff7b72= Te6edf3DatabaseTb4b4b4(Te6edf3pathTb4b4b4)

Te6edf3dbTff7b72.Td2a8ffinitializeTb4b4b4(Tb4b4b4)

Tff7b72return Te6edf3dbTb4b4b4, Te6edf3path

Tff7b72def Td2a8ff_store_enabled_configTb4b4b4(Tff7b72*Tff7b72*Te6edf3max_storedTb4b4b4)Tb4b4b4:

Te6edf3config Tff7b72= Te6edf3MagicMockTb4b4b4(Tb4b4b4)

Tff7b72for Te6edf3_k Tff7b72in Tb4b4b4(

Ta5d6ff"Ta5d6ffannounce_store_lxmf_deliveryTa5d6ff"Tb4b4b4,

Ta5d6ff"Ta5d6ffannounce_store_lxst_telephonyTa5d6ff"Tb4b4b4,

Ta5d6ff"Ta5d6ffannounce_store_nomadnetwork_nodeTa5d6ff"Tb4b4b4,

Ta5d6ff"Ta5d6ffannounce_store_lxmf_propagationTa5d6ff"Tb4b4b4,

Tb4b4b4)Tb4b4b4:

Te6edf3m Tff7b72= Te6edf3MagicMockTb4b4b4(Tb4b4b4)

Te6edf3mTff7b72.Td2a8ffgetTff7b72.Td2a8ffreturn_value Tff7b72= Tff7b72True

Tffa657setattrTb4b4b4(Te6edf3configTb4b4b4, Te6edf3_kTb4b4b4, Te6edf3mTb4b4b4)

Tff7b72for Te6edf3keyTb4b4b4, Te6edf3default Tff7b72in Tb4b4b4(

Tb4b4b4(Ta5d6ff"Ta5d6ffannounce_max_stored_lxmf_deliveryTa5d6ff"Tb4b4b4, Tff7b72NoneTb4b4b4)Tb4b4b4,

Tb4b4b4(Ta5d6ff"Ta5d6ffannounce_max_stored_nomadnetwork_nodeTa5d6ff"Tb4b4b4, Tff7b72NoneTb4b4b4)Tb4b4b4,

Tb4b4b4(Ta5d6ff"Ta5d6ffannounce_max_stored_lxmf_propagationTa5d6ff"Tb4b4b4, Tff7b72NoneTb4b4b4)Tb4b4b4,

Tb4b4b4)Tb4b4b4:

Te6edf3attr Tff7b72= Te6edf3MagicMockTb4b4b4(Tb4b4b4)

Te6edf3attrTff7b72.Td2a8ffgetTff7b72.Td2a8ffreturn_value Tff7b72= Te6edf3max_storedTff7b72.Td2a8ffgetTb4b4b4(Te6edf3keyTb4b4b4, Te6edf3defaultTb4b4b4)

Tffa657setattrTb4b4b4(Te6edf3configTb4b4b4, Te6edf3keyTb4b4b4, Te6edf3attrTb4b4b4)

Tff7b72return Te6edf3config

Tf0883e@pytestTff7b72.Td2a8fffixture

Tff7b72def Td2a8ffsqlite_dbTb4b4b4(Tb4b4b4)Tb4b4b4:

Te6edf3dbTb4b4b4, Te6edf3path Tff7b72= Te6edf3_new_dbTb4b4b4(Tb4b4b4)

Tff7b72yield Te6edf3dbTb4b4b4, Te6edf3path

Te6edf3_cleanupTb4b4b4(Te6edf3dbTb4b4b4, Te6edf3pathTb4b4b4)

Tff7b72def Td2a8fftest_spam_unique_destinations_stays_within_capTb4b4b4(Te6edf3sqlite_dbTb4b4b4)Tb4b4b4:

Te6edf3dbTb4b4b4, Te6edf3_path Tff7b72= Te6edf3sqlite_db

Te6edf3cap Tff7b72= T79c0ff48

Te6edf3cfg Tff7b72= Te6edf3_store_enabled_configTb4b4b4(Te6edf3announce_max_stored_lxmf_deliveryTff7b72=Te6edf3capTb4b4b4)

Te6edf3mgr Tff7b72= Te6edf3AnnounceManagerTb4b4b4(Te6edf3dbTb4b4b4, Te6edf3cfgTb4b4b4)

Te6edf3ret Tff7b72= Te6edf3MagicMockTb4b4b4(Tb4b4b4)

Te6edf3total Tff7b72= T79c0ff650

Tff7b72for Te6edf3i Tff7b72in Tffa657rangeTb4b4b4(Te6edf3totalTb4b4b4)Tb4b4b4:

Te6edf3dh Tff7b72= Ta5d6fffTa5d6ff"Tffd700{Te6edf3iTffd700:Ta5d6ff032xTffd700}Ta5d6ff"

Te6edf3mgrTff7b72.Td2a8ffupsert_announceTb4b4b4(

Te6edf3retTb4b4b4,

Te6edf3_FakeIdentityTb4b4b4(Ta5d6fffTa5d6ff"Tffd700{Te6edf3iTffd700:Ta5d6ff032xTffd700}Ta5d6ff"Tb4b4b4)Tb4b4b4,

Tffa657bytesTff7b72.Td2a8fffromhexTb4b4b4(Te6edf3dhTb4b4b4)Tb4b4b4,

Ta5d6ff"Ta5d6fflxmf.deliveryTa5d6ff"Tb4b4b4,

Ta5d6ffbTa5d6ff"Ta5d6ffxTa5d6ff"Tb4b4b4,

Tff7b72NoneTb4b4b4,

Tb4b4b4)

Tff7b72assert Te6edf3dbTff7b72.Td2a8ffannouncesTff7b72.Td2a8ffget_announce_count_by_aspectTb4b4b4(Ta5d6ff"Ta5d6fflxmf.deliveryTa5d6ff"Tb4b4b4) Tff7b72== Te6edf3cap

Tff7b72def Td2a8fftest_spam_same_destination_does_not_duplicate_rowsTb4b4b4(Te6edf3sqlite_dbTb4b4b4)Tb4b4b4:

Te6edf3dbTb4b4b4, Te6edf3_path Tff7b72= Te6edf3sqlite_db

Te6edf3cfg Tff7b72= Te6edf3_store_enabled_configTb4b4b4(Te6edf3announce_max_stored_lxmf_deliveryTff7b72=T79c0ff12Tb4b4b4)

Te6edf3mgr Tff7b72= Te6edf3AnnounceManagerTb4b4b4(Te6edf3dbTb4b4b4, Te6edf3cfgTb4b4b4)

Te6edf3ret Tff7b72= Te6edf3MagicMockTb4b4b4(Tb4b4b4)

Te6edf3dest Tff7b72= Tffa657bytesTff7b72.Td2a8fffromhexTb4b4b4(Ta5d6ff"Ta5d6ffabTa5d6ff" Tff7b72* T79c0ff16Tb4b4b4)

Te6edf3ident Tff7b72= Te6edf3_FakeIdentityTb4b4b4(Ta5d6ff"Ta5d6ffcdTa5d6ff" Tff7b72* T79c0ff16Tb4b4b4)

Tff7b72for Te6edf3_ Tff7b72in Tffa657rangeTb4b4b4(T79c0ff400Tb4b4b4)Tb4b4b4:

Te6edf3mgrTff7b72.Td2a8ffupsert_announceTb4b4b4(Te6edf3retTb4b4b4, Te6edf3identTb4b4b4, Te6edf3destTb4b4b4, Ta5d6ff"Ta5d6fflxmf.deliveryTa5d6ff"Tb4b4b4, Ta5d6ffbTa5d6ff"Ta5d6ffyTa5d6ff"Tb4b4b4, Tff7b72NoneTb4b4b4)

Te6edf3rows Tff7b72= Te6edf3dbTff7b72.Td2a8ffproviderTff7b72.Td2a8fffetchallTb4b4b4(

Ta5d6ff"Ta5d6ffSELECT COUNT(*) AS n FROM announces WHERE aspect = ? AND destination_hash = ?Ta5d6ff"Tb4b4b4,

Tb4b4b4(Ta5d6ff"Ta5d6fflxmf.deliveryTa5d6ff"Tb4b4b4, Ta5d6ff"Ta5d6ffabTa5d6ff" Tff7b72* T79c0ff16Tb4b4b4)Tb4b4b4,

Tb4b4b4)

Tff7b72assert Te6edf3rowsTb4b4b4[T79c0ff0Tb4b4b4]Tb4b4b4[Ta5d6ff"Ta5d6ffnTa5d6ff"Tb4b4b4] Tff7b72== T79c0ff1

Tff7b72assert Te6edf3dbTff7b72.Td2a8ffannouncesTff7b72.Td2a8ffget_announce_count_by_aspectTb4b4b4(Ta5d6ff"Ta5d6fflxmf.deliveryTa5d6ff"Tb4b4b4) Tff7b72== T79c0ff1

Tff7b72def Td2a8fftest_spam_interleaved_aspects_each_boundedTb4b4b4(Te6edf3sqlite_dbTb4b4b4)Tb4b4b4:

Te6edf3dbTb4b4b4, Te6edf3_path Tff7b72= Te6edf3sqlite_db

Te6edf3cfg Tff7b72= Te6edf3_store_enabled_configTb4b4b4(

Te6edf3announce_max_stored_lxmf_deliveryTff7b72=T79c0ff15Tb4b4b4,

Te6edf3announce_max_stored_nomadnetwork_nodeTff7b72=T79c0ff9Tb4b4b4,

Te6edf3announce_max_stored_lxmf_propagationTff7b72=T79c0ff11Tb4b4b4,

Tb4b4b4)

Te6edf3mgr Tff7b72= Te6edf3AnnounceManagerTb4b4b4(Te6edf3dbTb4b4b4, Te6edf3cfgTb4b4b4)

Te6edf3ret Tff7b72= Te6edf3MagicMockTb4b4b4(Tb4b4b4)

Tff7b72for Te6edf3round_i Tff7b72in Tffa657rangeTb4b4b4(T79c0ff120Tb4b4b4)Tb4b4b4:

Te6edf3i Tff7b72= Te6edf3round_i Tff7b72* T79c0ff3

Te6edf3mgrTff7b72.Td2a8ffupsert_announceTb4b4b4(

Te6edf3retTb4b4b4,

Te6edf3_FakeIdentityTb4b4b4(Ta5d6fffTa5d6ff"Tffd700{Te6edf3i Tff7b72+ T79c0ff1Tffd700:Ta5d6ff032xTffd700}Ta5d6ff"Tb4b4b4)Tb4b4b4,

Tffa657bytesTff7b72.Td2a8fffromhexTb4b4b4(Ta5d6fffTa5d6ff"Tffd700{Te6edf3i Tff7b72+ T79c0ff1Tffd700:Ta5d6ff032xTffd700}Ta5d6ff"Tb4b4b4)Tb4b4b4,

Ta5d6ff"Ta5d6fflxmf.deliveryTa5d6ff"Tb4b4b4,

Ta5d6ffbTa5d6ff"Ta5d6ffaTa5d6ff"Tb4b4b4,

Tff7b72NoneTb4b4b4,

Tb4b4b4)

Te6edf3mgrTff7b72.Td2a8ffupsert_announceTb4b4b4(

Te6edf3retTb4b4b4,

Te6edf3_FakeIdentityTb4b4b4(Ta5d6fffTa5d6ff"Tffd700{Te6edf3i Tff7b72+ T79c0ff2Tffd700:Ta5d6ff032xTffd700}Ta5d6ff"Tb4b4b4)Tb4b4b4,

Tffa657bytesTff7b72.Td2a8fffromhexTb4b4b4(Ta5d6fffTa5d6ff"Tffd700{Te6edf3i Tff7b72+ T79c0ff2Tffd700:Ta5d6ff032xTffd700}Ta5d6ff"Tb4b4b4)Tb4b4b4,

Ta5d6ff"Ta5d6ffnomadnetwork.nodeTa5d6ff"Tb4b4b4,

Ta5d6ffbTa5d6ff"Ta5d6ffbTa5d6ff"Tb4b4b4,

Tff7b72NoneTb4b4b4,

Tb4b4b4)

Te6edf3mgrTff7b72.Td2a8ffupsert_announceTb4b4b4(

Te6edf3retTb4b4b4,

Te6edf3_FakeIdentityTb4b4b4(Ta5d6fffTa5d6ff"Tffd700{Te6edf3i Tff7b72+ T79c0ff3Tffd700:Ta5d6ff032xTffd700}Ta5d6ff"Tb4b4b4)Tb4b4b4,

Tffa657bytesTff7b72.Td2a8fffromhexTb4b4b4(Ta5d6fffTa5d6ff"Tffd700{Te6edf3i Tff7b72+ T79c0ff3Tffd700:Ta5d6ff032xTffd700}Ta5d6ff"Tb4b4b4)Tb4b4b4,

Ta5d6ff"Ta5d6fflxmf.propagationTa5d6ff"Tb4b4b4,

Ta5d6ffbTa5d6ff"Ta5d6ffcTa5d6ff"Tb4b4b4,

Tff7b72NoneTb4b4b4,

Tb4b4b4)

Tff7b72assert Te6edf3dbTff7b72.Td2a8ffannouncesTff7b72.Td2a8ffget_announce_count_by_aspectTb4b4b4(Ta5d6ff"Ta5d6fflxmf.deliveryTa5d6ff"Tb4b4b4) Tff7b72== T79c0ff15

Tff7b72assert Te6edf3dbTff7b72.Td2a8ffannouncesTff7b72.Td2a8ffget_announce_count_by_aspectTb4b4b4(Ta5d6ff"Ta5d6ffnomadnetwork.nodeTa5d6ff"Tb4b4b4) Tff7b72== T79c0ff9

Tff7b72assert Te6edf3dbTff7b72.Td2a8ffannouncesTff7b72.Td2a8ffget_announce_count_by_aspectTb4b4b4(Ta5d6ff"Ta5d6fflxmf.propagationTa5d6ff"Tb4b4b4) Tff7b72== T79c0ff11

Tff7b72def Td2a8fftest_quick_check_ok_after_heavy_announce_spamTb4b4b4(Te6edf3sqlite_dbTb4b4b4)Tb4b4b4:

Te6edf3dbTb4b4b4, Te6edf3_path Tff7b72= Te6edf3sqlite_db

Te6edf3cfg Tff7b72= Te6edf3_store_enabled_configTb4b4b4(Te6edf3announce_max_stored_lxmf_deliveryTff7b72=T79c0ff30Tb4b4b4)

Te6edf3mgr Tff7b72= Te6edf3AnnounceManagerTb4b4b4(Te6edf3dbTb4b4b4, Te6edf3cfgTb4b4b4)

Te6edf3ret Tff7b72= Te6edf3MagicMockTb4b4b4(Tb4b4b4)

Tff7b72for Te6edf3i Tff7b72in Tffa657rangeTb4b4b4(T79c0ff900Tb4b4b4)Tb4b4b4:

Te6edf3mgrTff7b72.Td2a8ffupsert_announceTb4b4b4(

Te6edf3retTb4b4b4,

Te6edf3_FakeIdentityTb4b4b4(Ta5d6fffTa5d6ff"Tffd700{Te6edf3i Tff7b72% T79c0ff100Tffd700:Ta5d6ff032xTffd700}Ta5d6ff"Tb4b4b4)Tb4b4b4,

Tffa657bytesTff7b72.Td2a8fffromhexTb4b4b4(Ta5d6fffTa5d6ff"Tffd700{Te6edf3iTffd700:Ta5d6ff032xTffd700}Ta5d6ff"Tb4b4b4)Tb4b4b4,

Ta5d6ff"Ta5d6fflxmf.deliveryTa5d6ff"Tb4b4b4,

Te6edf3osTff7b72.Td2a8ffurandomTb4b4b4(T79c0ff64Tb4b4b4)Tb4b4b4,

Tff7b72NoneTb4b4b4,

Tb4b4b4)

Te6edf3qc Tff7b72= Te6edf3dbTff7b72.Td2a8ffproviderTff7b72.Td2a8ffquick_checkTb4b4b4(Tb4b4b4)

Tff7b72assert Te6edf3qc

Te6edf3first Tff7b72= Te6edf3qcTb4b4b4[T79c0ff0Tb4b4b4]

Te6edf3val Tff7b72= Tffa657nextTb4b4b4(Tffa657iterTb4b4b4(Te6edf3firstTff7b72.Td2a8ffvaluesTb4b4b4(Tb4b4b4)Tb4b4b4)Tb4b4b4)

Tff7b72assert Te6edf3val Tff7b72== Ta5d6ff"Ta5d6ffokTa5d6ff"

Tff7b72def Td2a8fftest_large_app_data_spam_remains_boundedTb4b4b4(Te6edf3sqlite_dbTb4b4b4)Tb4b4b4:

Te6edf3dbTb4b4b4, Te6edf3_path Tff7b72= Te6edf3sqlite_db

Te6edf3cfg Tff7b72= Te6edf3_store_enabled_configTb4b4b4(Te6edf3announce_max_stored_lxmf_deliveryTff7b72=T79c0ff20Tb4b4b4)

Te6edf3mgr Tff7b72= Te6edf3AnnounceManagerTb4b4b4(Te6edf3dbTb4b4b4, Te6edf3cfgTb4b4b4)

Te6edf3ret Tff7b72= Te6edf3MagicMockTb4b4b4(Tb4b4b4)

Te6edf3blob Tff7b72= Ta5d6ffbTa5d6ff"Ta5d6ffzTa5d6ff" Tff7b72* T79c0ff12000

Tff7b72for Te6edf3i Tff7b72in Tffa657rangeTb4b4b4(T79c0ff180Tb4b4b4)Tb4b4b4:

Te6edf3mgrTff7b72.Td2a8ffupsert_announceTb4b4b4(

Te6edf3retTb4b4b4,

Te6edf3_FakeIdentityTb4b4b4(Ta5d6fffTa5d6ff"Tffd700{Te6edf3iTffd700:Ta5d6ff032xTffd700}Ta5d6ff"Tb4b4b4)Tb4b4b4,

Tffa657bytesTff7b72.Td2a8fffromhexTb4b4b4(Ta5d6fffTa5d6ff"Tffd700{Te6edf3iTffd700:Ta5d6ff032xTffd700}Ta5d6ff"Tb4b4b4)Tb4b4b4,

Ta5d6ff"Ta5d6fflxmf.deliveryTa5d6ff"Tb4b4b4,

Te6edf3blobTb4b4b4,

Tff7b72NoneTb4b4b4,

Tb4b4b4)

Tff7b72assert Te6edf3dbTff7b72.Td2a8ffannouncesTff7b72.Td2a8ffget_announce_count_by_aspectTb4b4b4(Ta5d6ff"Ta5d6fflxmf.deliveryTa5d6ff"Tb4b4b4) Tff7b72== T79c0ff20